﻿<!DOCTYPE html>
<html>
	<head>
		<title>Save/print/download your spreadsheet</title>
		<meta charset="utf-8" />
		<meta name="description" content="Save, print and download your spreadsheet in various formats" />
		<link type="text/css" rel="stylesheet" href="../../../../../../common/main/resources/help/editor.css" />
		<link type = "text/css" rel = "stylesheet" href = "../../images/sprite.css" />
        <script type="text/javascript" src="../callback.js"></script>
        <script type="text/javascript" src="../search/js/page-search.js"></script>
	</head>
	<body>
        <div class="mainpart">
            <div class="search-field">
                <input id="search" class="searchBar" placeholder="Search" type="text" onkeypress="doSearch(event)">
            </div>
            <h1>Save/print/download your spreadsheet</h1>
            <h3>Saving</h3>
            <p class="onlineDocumentFeatures">By default, the online <a href="https://www.onlyoffice.com/en/spreadsheet-editor.aspx" target="_blank" onclick="onhyperlinkclick(this)"><b>Spreadsheet Editor</b></a> automatically saves your file each 2 seconds when you are working on it preventing your data from loss if the program closes unexpectedly. If you co-edit the file in the <b>Fast</b> mode, the timer requests for updates 25 times a second and saves the changes if they have been made. When the file is being co-edited in the <b>Strict</b> mode, changes are automatically saved at 10-minute intervals. If you need, you can easily select the preferred co-editing mode or disable the <b>Autosave</b> feature on the <a href="../HelpfulHints/AdvancedSettings.htm" onclick="onhyperlinkclick(this)">Advanced Settings</a> page.</p>
            <p>To save your current spreadsheet manually in the current format and location,</p>
            <ul>
                <li>click the <b>Save</b> <div class = "icon icon-save"></div> icon on the left side of the editor header, or</li>
                <li>use the <b>Ctrl+S</b> key combination, or</li>
                <li>click the <b>File</b> tab of the top toolbar and select the <b>Save</b> option.</li>
            </ul>
            <p class="note desktopDocumentFeatures">In the <em>desktop version</em>, to prevent data loss if the program closes unexpectedly, you can turn on the <b>Autorecover</b> option on the <a href="../HelpfulHints/AdvancedSettings.htm" onclick="onhyperlinkclick(this)">Advanced Settings</a> page. </p>
            <div class="desktopDocumentFeatures">
                <p>In the <em>desktop version</em>, you can save the spreadsheet with another name, in a new location or format,</p>
                <ol>
                    <li>click the <b>File</b> tab of the top toolbar,</li>
                    <li>select the <b>Save as</b> option,</li>
                    <li>choose one of the available formats depending on your needs: XLSX, XLTX, ODS, OTS, CSV, PDF, PDF/A, XLTM, JPG, PNG.</li>
                </ol>
            </div>
            <div class="onlineDocumentFeatures">
                <h3>Downloading</h3>
                <p>In the <em>online version</em>, you can download the resulting spreadsheet onto your computer hard disk drive,</p>
                <ol>
                    <li>click the <b>File</b> tab of the top toolbar,</li>
                    <li>select the <b>Download as</b> option,</li>
                    <li>
                        choose one of the available formats depending on your needs: XLSX, ODS, CSV, PDF, XLTX, OTS, PDF/A, JPG, PNG.
                        <p class="note"><b>Note</b>: if you select the CSV format, all features (font formatting, formulas, etc.) except the plain text will not be preserved in the CSV file. If you continue saving, the <b>Choose CSV Options</b> window will open. By default, <em>Unicode (UTF-8)</em> is used as the <b>Encoding</b> type. The default <b>Delimiter</b> is <em>comma</em> (,), but the following options are also available: <em>semicolon</em> (;), <em>colon</em> (:), <em>Tab</em>, <em>Space</em> and <em>Other</em> (this option allows you to set a custom delimiter character).</p>
                    </li>
                </ol>
                <h3>Saving a copy</h3>
                <p>In the <em>online version</em>, you can save a copy of the file on your portal,</p>
                <ol>
                    <li>click the <b>File</b> tab of the top toolbar,</li>
                    <li>select the <b>Save Copy as</b> option,</li>
                    <li>choose one of the available formats depending on your needs: XLSX, ODS, CSV, PDF, XLTX, OTS, PDF/A, JPG, PNG,</li>
                    <li>select a location of the file on the portal and press <b>Save</b>.</li>
                </ol>
            </div>
            <h3 id="print">Printing</h3>
            <p>To print out the current spreadsheet,</p>
            <ul>
                <li>click the <b>Print</b> <div class = "icon icon-print"></div> icon on the left side of the editor header, or</li>
                <li>use the <b>Ctrl+P</b> key combination, or</li>
                <li>click the <b>File</b> tab of the top toolbar and select the <b>Print</b> option.</li>
            </ul>
            <div class="note">
                The Firefox browser enables printing without downloading the document as a .pdf file first.
            </div>
            <p>The spreadsheet <b>Preview</b> and the available printing options will open.</p>
            <p class="note">Some of these settings (page <b>Margins</b>, <b>Orientation</b>, <b>Size</b>, <b>Print Area</b> as well as <a href="ScaleToFit.htm" onclick="onhyperlinkclick(this)"><b>Scale to Fit</b></a>) are also available on the <b>Layout</b> tab of the top toolbar.</p>
            <p><img alt="Print Settings window" src="../images/printsettingswindow.png" /></p>
            <p>Here you can adjust the following parameters<span class="desktopDocumentFeatures">. In the <em>desktop version</em> you can also define the <b>Print sides</b> option to print on <b>one</b> or <b>two sides</b> flipping the pages on long or short edge as well as <b>print the file to PDF</b> or use the <b>Quick print</b> button in the top toolbar to print the file on the last selected or default printer.</span></p>
            <ul id="printtitles">
                <li>
                    <b>Print range</b> - specify what to print: <b>Active sheets</b>, <b>All sheets</b> or <b>Selection</b>.
                    <p>If you previously set a constant print area but want to print the entire sheet, check the <b>Ignore print area</b> box.</p>
                </li>
                <li><b>Pages</b> - specify the range of pages for printing. You can enter the numbers manually or use the corresponding arrows.</li>
                <li><b>Settings of sheet</b> - specify individual print settings for each separate sheet, if you have selected the <b>All Sheets</b> option in the <b>Print range</b> drop-down list.</li>
                <li><b>Page size</b> - select one of the available sizes from the drop-down list.</li>
                <li><b>Page orientation</b> - choose the <b>Portrait</b> option if you wish to print vertically on the page, or use the <b>Landscape</b> option to print horizontally.</li>
                <li><b>Margins</b> - choose one of the availabe presets: <em>Normal</em>, <em>Narrow</em>, or <em>Wide</em>, or choose the <b>Custom</b> option and specify the distance between the worksheet data and the edges of the printed page changing the default sizes in the <b>Top</b>, <b>Bottom</b>, <b>Left</b> and <b>Right</b> fields.
                <p>To center data on the printed page, choose the <b>Custom</b> option from the <b>Margins</b> menu, check the <b>Vertically</b>/<b>Horizontally</b> box in the <b>Center on page</b> section, and click <b>OK</b>.</p>
                    <p><img alt="Margins window" src="../images/margins.png" /></p>
                </li>
                <li>
                    <b>Scaling</b> - if you do not want some columns or rows to be printed on the second page, you can shrink sheet contents to fit it on one page by selecting the corresponding option: <b>Actual Size</b>, <b>Fit Sheet on One Page</b>, <b>Fit All Columns on One Page</b> or <b>Fit All Rows on One Page</b>. Leave the <b>Actual Size</b> option to print the sheet without adjusting.
                    <p>If you choose the <b>Custom Options</b> item from the menu, the <b>Scale Settings</b> window will open:</p>
                    <p><img alt="Scale Settings window" src="../images/scalesettings.png" /></p>
                    <ol>
                        <li><b>Fit To</b>: allows you to select the necessary number of pages you want to fit the printed worksheet to. Select the necessary number of pages from the <b>Width</b> and <b>Height</b> lists.</li>
                        <li><b>Scale To</b>: allows you to enlarge or reduce the scale of the worksheet to fit printed pages by manually specifying the percentage of normal size.</li>
                    </ol>
                </li>
                <li><b>Print titles</b> - if you want to print row or column titles on every page, use <b>Repeat rows at top</b> and/or <b>Repeat columns at left</b> to indicate the row and the column with the title to repeat, or select one of the available options from the drop-down list: Frozen rows/columns, First row/column or Don't repeat.</li>
                <li><b>Gridlines and headings</b> - specify the worksheet elements to print by checking the corresponding boxes: <b>Print gridlines</b> and <b>Print row and column headings</b>.</li>
                <li>
                    <a href="../UsageInstructions/InsertHeadersFooters.htm" onclick="onhyperlinkclick(this)"><b>Header/footer settings</b></a> - allow to add some additional information to a printed worksheet, such as date and time, page number, sheet name, etc.
                </li>
                <li><b>First page number</b> - specify the number of the first page printed.</li>
            </ul>
            <p>After you have configured the printing settings click the <b>Print</b> button to save changes and print out the spreadsheet or the <b>Save</b> button to save changes made to printing settings.</p>
            <p class="note">All changes you made will be lost if you don't print the spreadsheet or save the changes.</p>
            <p>The spreadsheet <b>Preview</b> allows you to navigate a spreadsheet using arrows at the bottom to see how your data will be displayed on a sheet when printed and to correct eventual faults using the print setting above.</p>
            <p><span class="onlineDocumentFeatures">In the <em>online version</em>, a PDF file will be generated on the basis of the document. You can open and print it out, or save onto your computer hard disk drive or removable medium to print it out later. Some browsers (e.g. Chrome and Opera) support direct printing.</span></p>
            <h4 id="printarea">Setting up the print area</h4>
            <p>If you want to print the selected cell range only instead of the entire worksheet, you can use the <b>Selection</b> option from the <b>Print range</b> drop-down list. When the workbook is saved, this setting is not saved, it is intended for single use. </p>
            <p>If a cell range should be printed frequently, you can set a constant print area on the worksheet. When the workbook is saved, the print area is also saved, it can be used when you open the spreadsheet next time. It's also possible to set several constant print areas in a sheet, in this case each area will be printed on a separate page.</p>
            <p>To set the print area:</p>
            <ol>
                <li>select the necessary cell range on the worksheet. To select multiple cell ranges, hold down the <em>Ctrl</em> key,</li>
                <li>switch to the <b>Layout</b> tab of the top toolbar,</li>
                <li>click the arrow next to the <div class = "icon icon-printareabutton"></div> <b>Print Area</b> button and select the <b>Set Print Area</b> option.</li>
            </ol>
            <p>The created print area is saved when the workbook is saved. When you open the file next time, the specified print area will be printed.</p>
            <p class="note">When you create a print area, a <em>Print_Area</em> <a href="UseNamedRanges.htm" onclick="onhyperlinkclick(this)">named range</a> is also automatically created, which is displayed in the <b>Name Manager</b>. To highlight the borders of all the print areas on the current worksheet, you can click the arrow in the name box located to the left of the the formula bar and select the <em>Print_Area</em> name from the name list. </p>
            <p>To add cells to the print area:</p>
            <ol>
                <li>open the necessary worksheet where the print area is added,</li>
                <li>select the necessary cell range on the worksheet,</li>
                <li>switch to the <b>Layout</b> tab of the top toolbar,</li>
                <li>click the arrow next to the <div class = "icon icon-printareabutton"></div> <b>Print Area</b> button and select the <b>Add to Print Area</b> option.</li>
            </ol>
            <p><!--If the selected cell range is adjacent to the existing print area, it will be added to this print area. If the selected cell range is not adjacent to the existing print area,--> A new print area will be added. Each print area will be printed on a separate page.</p>
            <p>To remove the print area:</p>
            <ol>
                <li>open the necessary worksheet where the print area is added,</li>
                <li>switch to the <b>Layout</b> tab of the top toolbar,</li>
                <li>click the arrow next to the <div class = "icon icon-printareabutton"></div> <b>Print Area</b> button and select the <b>Clear Print Area</b> option.</li>
            </ol>
            <p>All the existing print areas in this sheet will be removed. Then the entire sheet will be printed.</p>
        </div>
	</body>
</html>